﻿CREATE TABLE [v1bgt].[CompanyJournalSet] (
    [CompanyJournalSetId]      INT           IDENTITY (1, 1) NOT NULL,
    [JournalSetTypeId]         SMALLINT      NOT NULL,
    [JournalSetName]           VARCHAR (50)  NULL,
    [JournalSetDescription]    VARCHAR (200) NULL,
    [PeriodStartDate]          DATETIME      NOT NULL,
    [PeriodEndDate]            DATETIME      NOT NULL,
    [DefaultReferenceMonth]    DATETIME      NOT NULL,
    [JournalSetActivityStatus] CHAR (3)      NULL,
    [CreatedBy]                VARCHAR (50)  NULL,
    [UpdatedBy]                VARCHAR (50)  NULL,
    [CreateDate]               DATETIME      NOT NULL,
    [UpdateDate]               DATETIME      NOT NULL,
    [PublishedFlag]            CHAR (1)      NULL,
    PRIMARY KEY CLUSTERED ([CompanyJournalSetId] ASC) WITH (FILLFACTOR = 90, ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

